﻿CREATE VIEW dbo.ValFull
AS
SELECT     dbo.Val.Benamning AS ValNamn, dbo.Val.ValDatum, dbo.ValkretsFull.ValkretsNamn, dbo.ValkretsFull.ValkretsNr, dbo.ValkretsFull.ForsamlingNamn, 
                      dbo.ValkretsFull.ForsamlingNr, dbo.ValkretsFull.ValdistriktNr, dbo.ValkretsFull.LokalBenamning, dbo.ValkretsFull.ByggnadBenamning, 
                      dbo.ValkretsFull.ByggnadBesokPostNr, dbo.ValkretsFull.ByggnadBesokPostOrt, dbo.ValkretsFull.ByggnadBesokAdress, dbo.ValkretsFull.ByggnadStadsdelID, 
                      dbo.ValkretsFull.ByggnadStadsdel, dbo.ValkretsFull.ByggnadTypID, dbo.ValkretsFull.ByggnadTyp, dbo.ValkretsFull.ByggnadStatus, dbo.ValkretsFull.ByggnadStatusID,
                       dbo.ValkretsFull.PersonPersonnummer, dbo.ValkretsFull.PersonFornamn, dbo.ValkretsFull.PersonEfternamn, dbo.ValkretsFull.PersonTelNr, 
                      dbo.ValkretsFull.PersonMobTelNr, dbo.ValkretsFull.PersonEpost, dbo.ValkretsFull.PersonAdress, dbo.ValkretsFull.PersonPostNr, dbo.ValkretsFull.PersonPostOrt, 
                      dbo.ValkretsFull.PersonFritext, dbo.ValkretsFull.PersonStatus, dbo.ValkretsFull.PersonStatusID, dbo.ValkretsFull.PersonTyp, dbo.GruppFull.GruppNamn, 
                      dbo.ValkretsFull.ValId, dbo.ValkretsFull.ValkretsId, dbo.ValkretsFull.ForsamlingId, dbo.ValkretsFull.ValdistriktId
FROM         dbo.Val LEFT OUTER JOIN
                      dbo.ValkretsFull ON dbo.ValkretsFull.ValId = dbo.Val.Id LEFT OUTER JOIN
                      dbo.GruppFull ON dbo.GruppFull.ValId = dbo.Val.Id
GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPaneCount', @value = 2, @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'ValFull';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane2', @value = N'3210
         Alias = 2880
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'ValFull';




GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane1', @value = N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[42] 4[52] 2[4] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = -96
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Val"
            Begin Extent = 
               Top = 117
               Left = 414
               Bottom = 340
               Right = 585
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ValkretsFull"
            Begin Extent = 
               Top = 0
               Left = 935
               Bottom = 524
               Right = 1122
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GruppFull"
            Begin Extent = 
               Top = 329
               Left = 633
               Bottom = 615
               Right = 817
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 33
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column =', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'ValFull';





